Lookup Exact Registry entry
Specify that a value entered into a Lookup List field must match exactly with an existing value in the Lookup List.
This entry ensures that if a term entered into a Lookup List field varies from an existing term (due to case or punctuation for instance), the user is notified that a new term has been entered, allowing them to add the variation to the list or choose an existing term. In a ReadOnly Lookup List it is necessary to choose an existing value (no variation will be recogni
The addition of Unicode support with
When comparing Lookup List entries prior to Smith (?)
was treated the same as an entry for Smith
, so only one value (the first one entered in the system) would be stored.
When working with Lookup List values it is important to recogniZoe
and Zoë
are different Lookup List values. It is important to keep this in mind when using the Lookup Exact Registry entry, for example.
Usage
This Registry entry can be assigned to users and groups:
Key | User | User | Group | Group | Group | Group |
---|---|---|---|---|---|---|
Key 1 | User
|
User
|
Group
|
Group
|
Group
|
Group
|
Key 2 | user | user | group | group | Default
|
Default
|
Key 3 | Table
|
Table
|
Table
|
Table
|
Table
|
Table
|
Key 4 | table | Default
|
table | Default
|
table | Default
|
Key 5 | Lookup Exact
|
|||||
Key 6 | column or Default |
|||||
Value | boolean |
User
|
user | Table
|
table | Lookup Exact
|
column | boolean |
User
|
user | Table
|
Default
|
Lookup Exact
|
column | boolean |
Group
|
group | Table
|
table | Lookup Exact
|
column | boolean |
Group
|
group | Table
|
Default
|
Lookup Exact
|
column | boolean |
Group
|
Default
|
Table
|
table | Lookup Exact
|
column | boolean |
Group
|
Default
|
Table
|
Default
|
Lookup Exact
|
column | boolean |
User
|
user | Table
|
table | Lookup Exact
|
Default
|
boolean |
User
|
user | Table
|
Default
|
Lookup Exact
|
Default
|
boolean |
Group
|
group | Table
|
table | Lookup Exact
|
Default
|
boolean |
Group
|
group | Table
|
Default
|
Lookup Exact
|
Default
|
boolean |
Group
|
Default
|
Table
|
table | Lookup Exact
|
Default
|
boolean |
Group
|
Default
|
Table
|
Default
|
Lookup Exact
|
Default
|
boolean |
where:
column |
is the name of a Lookup List column to which to apply Lookup Exact. By setting column to |
boolean |
is Note:
If this entry is not present, a setting of |
Examples
This example applies Lookup Exact system wide:
Key | Setting |
---|---|
Key 1 | Group
|
Key 2 | Default
|
Key 3 | Table
|
Key 4 | Default
|
Key 5 | Lookup Exact
|
Key 6 | Default
|
Value | true
|
This example applies Lookup Exact on all Lookup Lists in the Parties module for all users:
Key | Setting |
---|---|
Key 1 | Group
|
Key 2 | Default
|
Key 3 | Table
|
Key 4 | eparties
|
Key 5 | Lookup Exact
|
Key 6 | Default
|
Value | true
|